<?php

class ShowCategoryController extends Controller
{
	public function actionIndex()
	{
		$sql = "SELECT category_id as id,name_thai,name_eng FROM category"; // ����� SQL ����ͧ���

          $dataProvider = new CSqlDataProvider($sql, array(    // ��� sql �ŧ�� dataProvider
          'pagination' => array(
          'pageSize' => 10,        // ��˹����˹�ҹ֧�ʴ� 10 ��¡��
          ),
          ));

          $this->render('showCategory', array('dataProvider' => $dataProvider));   // �觵������ѧ view
		//$this->render('index');
	}

	// Uncomment the following methods and override them if needed
	/*
	public function filters()
	{
		// return the filter configuration for this controller, e.g.:
		return array(
			'inlineFilterName',
			array(
				'class'=>'path.to.FilterClass',
				'propertyName'=>'propertyValue',
			),
		);
	}

	public function actions()
	{
		// return external action classes, e.g.:
		return array(
			'action1'=>'path.to.ActionClass',
			'action2'=>array(
				'class'=>'path.to.AnotherActionClass',
				'propertyName'=>'propertyValue',
			),
		);
	}
	*/
}